How to: Force a page break in the Detail section of a report.
Solution:
In the Report Design view, use the 'Force New Page' property box in the property sheet of the report to force a page break in the Detail section of a report.
1) If the Database window is not active, activate the Database window.
2) Click the 'Reports' tab in the Database window.
Reports tab
3) Select the desired report from the list box. (The selected report is highlighted.)
4) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
5) Select the 'Detail' section.
Section Selecting
6) Select the 'View' menu and select 'Properties'.
7) Click the 'Format' tab.
8) Click on the 'Force New Page' box. (A down arrow appears.)
9) Click down arrow. (A drop-down list appears.)
Page Break in Detail
10) Do one of the following:
a) Select 'Before Section' to have the Detail section print at the top of a new page.
b) Select 'After Section' to have the next section after the Detail section print at the top of a new page.
c) Select 'Before & After' to have the Detail section print at the top of a new page and the next section print at the top of a new page.
11) Select the 'File' menu and select 'Save' to save the report.
